﻿/********************************************************************************************************************
* Author:	Aristidis Mihail																						*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_category_delete_user_from_category"	*		
*			 that deletes a user from a private category.															*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_category_delete_user_from_category]
	@categoryID bigint,
	@userid bigint
AS
	DELETE FROM [Category-User]
	WHERE CategoryID=@categoryID AND UserID=@userid

RETURN 0